CREATE PROCEDURE spSelectGroupByID
   @GroupID INT
AS
BEGIN
   SELECT
      *
   FROM
      tblGroups
   WHERE
      GroupID = @GroupID
END
GO